package com.shujia.common.kylin

import com.shujia.common.kylin.dao.DBUtil

object Test {
  def main(args: Array[String]): Unit = {

    val resultSet = DBUtil.select("select d_city_name,sum(only_pt) as s from dal_tour_city_day_index where day_id='20180503' and d_city_id='83401' group by d_city_name")

    while (resultSet.next()) {
      val clazz = resultSet.getString("d_city_name")
      val c = resultSet.getLong("s")

      println(clazz + "\t" + c)
    }
  }

}
